<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-19. 16:42:12-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Business Unit Summary of Capacity with Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="All Applications">
			<contents><textItem><dataSource><dataItemValue refDataItem="App Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Business Unit Allocated</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="All Business Units">
			<contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Allocated</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="All Applications">
			<contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used by BU</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="All Business Units">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Cap (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used by Apps</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="All Applications">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Cap (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Allocated Capacity)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart9" refQuery="Top BUs">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="12">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Allocated (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange scale="linear">
                                        <v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:650px;height:400px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;margin-top:5px;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>All Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Allocated Capacity)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="All Business Units" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Cap (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Cap (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Allocated (TB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Allocated Capacity)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
					<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart10" refQuery="Top Apps">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="12">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Allocated (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange scale="linear">
                                        <v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:650px;height:400px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;margin-top:5px;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>All Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Allocated Capacity)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" refQuery="All Applications" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Cap (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Cap (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Allocated (TB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>2.22 Business Unit Capacity Summary with Applications</reportName><queries><query name="All Business Units">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>SELECT

cap.application as 'Application',
cap.businessunit as 'Business Unit',
ROUND(SUM(cap.allocatedCapTB),2) as 'Allocated (TB)',
ROUND(SUM(cap.usedCapTB),2) as 'Used Cap (TB)'



FROM
(
SELECT
	(dwh_inventory.volume.capacityMB/1024/1024) AS allocatedCapTB,
	(dwh_inventory.volume.consumedCapacityMB/1024/1024) AS usedCapTB,
	dwh_inventory.application.name as application,
	dwh_inventory.application.businessunit as businessunit
    
FROM 	dwh_inventory.volume
JOIN	dwh_inventory.volume_to_application
ON	dwh_inventory.volume_to_application.volumeid=dwh_inventory.volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.volume_to_application.applicationId

WHERE dwh_inventory.application.businessunit&lt;&gt;'N/A'	
      
GROUP BY dwh_inventory.volume.id

UNION

SELECT
(dwh_inventory.internal_volume.dataAllocatedCapacityMB/1024/1024) as allocatedCapTB,
(dwh_inventory.internal_volume.dataUsedCapacityMB/1024/1024) as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM 	dwh_inventory.internal_volume
JOIN	dwh_inventory.storage_pool
ON	dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagePoolId
JOIN	dwh_inventory.internal_volume_to_application
ON	dwh_inventory.internal_volume_to_application.internalVolumeId=dwh_inventory.internal_volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.internal_volume_to_application.applicationId

WHERE dwh_inventory.application.businessunit&lt;&gt;'N/A'

GROUP BY dwh_inventory.internal_volume.id


UNION

SELECT
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024/1024 as allocatedCapTB,
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024/1024 as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM dwh_inventory.hv_virtual_machine
JOIN  dwh_inventory.vm_to_application
ON    dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid
WHERE dwh_inventory.application.businessunit &lt;&gt; 'N/A'

GROUP BY dwh_inventory.hv_virtual_machine.id

) cap

GROUP BY cap.businessunit

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used Cap (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL1].[Allocated (TB)]</expression></dataItem><dataItem name="Used Cap (TB)" aggregate="total"><expression>[SQL1].[Used Cap (TB)]</expression></dataItem><dataItem name="% Used"><expression>[Used Cap (TB)]/[Allocated (TB)]</expression></dataItem></selection>
		</query><query name="All Applications">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>SELECT

cap.application as 'Application',
cap.businessunit as 'Business Unit',
ROUND(SUM(cap.allocatedCapTB),2) as 'Allocated (TB)',
ROUND(SUM(cap.usedCapTB),2) as 'Used Cap (TB)'



FROM
(
SELECT
	(dwh_inventory.volume.capacityMB/1024/1024) AS allocatedCapTB,
	(dwh_inventory.volume.consumedCapacityMB/1024/1024) AS usedCapTB,
	dwh_inventory.application.name as application,
	dwh_inventory.application.businessunit as businessunit
    
FROM 	dwh_inventory.volume
JOIN	dwh_inventory.volume_to_application
ON	dwh_inventory.volume_to_application.volumeid=dwh_inventory.volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.volume_to_application.applicationId

WHERE dwh_inventory.application.name&lt;&gt;'N/A'	
      
GROUP BY dwh_inventory.volume.id

UNION

SELECT
(dwh_inventory.internal_volume.dataAllocatedCapacityMB/1024/1024) as allocatedCapTB,
(dwh_inventory.internal_volume.dataUsedCapacityMB/1024/1024) as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM 	dwh_inventory.internal_volume
JOIN	dwh_inventory.storage_pool
ON	dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagePoolId
JOIN	dwh_inventory.internal_volume_to_application
ON	dwh_inventory.internal_volume_to_application.internalVolumeId=dwh_inventory.internal_volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.internal_volume_to_application.applicationId

WHERE dwh_inventory.application.name&lt;&gt;'N/A'

GROUP BY dwh_inventory.internal_volume.id


UNION

SELECT
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024/1024 as allocatedCapTB,
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024/1024 as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM dwh_inventory.hv_virtual_machine
JOIN  dwh_inventory.vm_to_application
ON    dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid
WHERE dwh_inventory.application.name &lt;&gt; 'N/A'

GROUP BY dwh_inventory.hv_virtual_machine.id


) cap

GROUP BY cap.application

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used Cap (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL1].[Allocated (TB)]</expression></dataItem><dataItem name="Used Cap (TB)" aggregate="total"><expression>[SQL1].[Used Cap (TB)]</expression></dataItem><dataItem name="% Used"><expression>[Used Cap (TB)]/[Allocated (TB)]</expression></dataItem><dataItem name="App Count" aggregate="total"><expression>COUNT(DISTINCT [Application] for Report)</expression></dataItem></selection>
		</query><query name="Top Apps">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

cap.application as 'Application',
cap.businessunit as 'Business Unit',
ROUND(SUM(cap.allocatedCapTB),2) as 'Allocated (TB)',
ROUND(SUM(cap.usedCapTB),2) as 'Used Cap (TB)'



FROM
(
SELECT
	(dwh_inventory.volume.capacityMB/1024/1024) AS allocatedCapTB,
	(dwh_inventory.volume.consumedCapacityMB/1024/1024) AS usedCapTB,
	dwh_inventory.application.name as application,
	dwh_inventory.application.businessunit as businessunit
    
FROM 	dwh_inventory.volume
JOIN	dwh_inventory.volume_to_application
ON	dwh_inventory.volume_to_application.volumeid=dwh_inventory.volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.volume_to_application.applicationId

WHERE dwh_inventory.application.name&lt;&gt;'N/A'	
      
GROUP BY dwh_inventory.volume.id

UNION

SELECT
(dwh_inventory.internal_volume.dataAllocatedCapacityMB/1024/1024) as allocatedCapTB,
(dwh_inventory.internal_volume.dataUsedCapacityMB/1024/1024) as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM 	dwh_inventory.internal_volume
JOIN	dwh_inventory.storage_pool
ON	dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagePoolId
JOIN	dwh_inventory.internal_volume_to_application
ON	dwh_inventory.internal_volume_to_application.internalVolumeId=dwh_inventory.internal_volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.internal_volume_to_application.applicationId

WHERE dwh_inventory.application.name&lt;&gt;'N/A'

GROUP BY dwh_inventory.internal_volume.id


UNION

SELECT
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024/1024 as allocatedCapTB,
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024/1024 as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM dwh_inventory.hv_virtual_machine
JOIN  dwh_inventory.vm_to_application
ON    dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid
WHERE dwh_inventory.application.name &lt;&gt; 'N/A'

GROUP BY dwh_inventory.hv_virtual_machine.id


) cap

GROUP BY cap.application

ORDER BY 'Allocated (TB)' DESC LIMIT 10
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used Cap (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Allocated (TB)" aggregate="total"><expression>[SQL2].[Allocated (TB)]</expression></dataItem><dataItem name="Used Cap (TB)" aggregate="total"><expression>[SQL2].[Used Cap (TB)]</expression></dataItem><dataItem name="Used %" rollupAggregate="total"><expression>[SQL2].[% Used]</expression></dataItem><dataItem name="rank"><expression>rank([Allocated (TB)])</expression></dataItem></selection>
		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="Top BUs">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

cap.application as 'Application',
cap.businessunit as 'Business Unit',
ROUND(SUM(cap.allocatedCapTB),2) as 'Allocated (TB)',
ROUND(SUM(cap.usedCapTB),2) as 'Used Cap (TB)'



FROM
(
SELECT
	(dwh_inventory.volume.capacityMB/1024/1024) AS allocatedCapTB,
	(dwh_inventory.volume.consumedCapacityMB/1024/1024) AS usedCapTB,
	dwh_inventory.application.name as application,
	dwh_inventory.application.businessunit as businessunit
    
FROM 	dwh_inventory.volume
JOIN	dwh_inventory.volume_to_application
ON	dwh_inventory.volume_to_application.volumeid=dwh_inventory.volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.volume_to_application.applicationId

WHERE dwh_inventory.application.businessunit&lt;&gt;'N/A'	
      
GROUP BY dwh_inventory.volume.id

UNION

SELECT
(dwh_inventory.internal_volume.dataAllocatedCapacityMB/1024/1024) as allocatedCapTB,
(dwh_inventory.internal_volume.dataUsedCapacityMB/1024/1024) as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM 	dwh_inventory.internal_volume
JOIN	dwh_inventory.storage_pool
ON	dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagePoolId
JOIN	dwh_inventory.internal_volume_to_application
ON	dwh_inventory.internal_volume_to_application.internalVolumeId=dwh_inventory.internal_volume.id
JOIN 	dwh_inventory.application
ON	dwh_inventory.application.id=dwh_inventory.internal_volume_to_application.applicationId

WHERE dwh_inventory.application.businessunit&lt;&gt;'N/A'

GROUP BY dwh_inventory.internal_volume.id


UNION

SELECT
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024/1024 as allocatedCapTB,
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024/1024 as usedCapTB,
dwh_inventory.application.name as application,
dwh_inventory.application.businessunit as businessunit

FROM dwh_inventory.hv_virtual_machine
JOIN  dwh_inventory.vm_to_application
ON    dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid
WHERE dwh_inventory.application.businessunit &lt;&gt; 'N/A'

GROUP BY dwh_inventory.hv_virtual_machine.id

) cap

GROUP BY cap.businessunit

ORDER BY 'Allocated (TB)' DESC LIMIT 10
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used Cap (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Allocated (TB)" aggregate="total"><expression>[SQL3].[Allocated (TB)]</expression></dataItem><dataItem name="Used Cap (TB)" aggregate="total"><expression>[SQL3].[Used Cap (TB)]</expression></dataItem><dataItem name="% Used" rollupAggregate="total"><expression>[Used Cap (TB)]/[Allocated (TB)]</expression></dataItem></selection>
		</query><query name="Query1">
			<source>
				<model/>
			</source>
			<selection/>
		</query></queries></report>